Tabular Model - General Ledger

Contents

Usage/Purpose

The main purpose of the General Ledger tabular model is to produce financial statements and visualizations based on IFS General Ledger Transactions in combination with planned values from IFS Business Planning and Budget version. Main reporting tools are Power BI and Excel Pivot Analysis

To be able to use the general ledger model the balances from the different sources have to be mapped into Balance Sets. A balance set is a definition of your financial balances either in the past or in the future. It can be actuals or planning or a combination of both. The model has four pre-defined balance sets for ACT (Actuals), BUD (Budget), CFC (Current Forecast) and NFC (Next Forecast).

Each pre-defined Balance set comes with pre-calculated measures such as YTD (Year To Date), PY (Previous Year) and R12 (Rolling 12).

To take full advantage of the general ledger model it is recommended to set up Accounting Structures for Income Statement and Balance Sheet. By doing so the model will provide dynamic out of the box analysis capabilities.

The analysis can be conducted in Transaction Currency, Accounting Currency or in a common currency named X-rate. X-rate measures translates all balances using the Currency rate types and the connected Currency rates of a selected company. Using the X-rate for example makes it possible to compare actuals (translated with actual rates) with actuals translated with other rates (e.g. with budget or previous year rates).

There are two different methods to translate accounting currency to X-rate. Period based method use the last available rate of the period to translate the period amount and then accumulate the period amounts to get to the YTD amount. YTD based method use the last available rate of the period to translate the YTD amount and then subtract the YTD amount of the previous period to get to the period amount.

To produce more dynamic reports and taking advantage of the large number of pre-defined measures it is recommended to use Switch measures in combination with pre-defined slicers. By doing so it possible to switch between period and YTD amounts and to dynamically switch comparison measure (BUD, CFC, NFC, PY).

Reporting Period

Reporting periods are created to provide a common calendar structure regardless of how companies have configured their local accounting calendars and how they are using closing periods. Reporting periods are provided to support operational reporting and analysis with a common view for an organization and across companies.

All measures are based on reporting periods if nothing else is stated. The reporting periods are based on the accounting periods (fiscal year) of one selected company. If companies within the group have different accounting period setup (different fiscal year), those periods need to be mapped to the relevant reporting periods common for all companies. Furthermore, year-end periods can be mapped to a reporting period (normally the last “ordinary” period). This, in combination with the x-rate functionality, means the income statement can be analyzed on aggregated level (sub-group or group) without running it through a consolidation tool - even when companies within the group uses different fiscal years.

The reporting period measures can also be used to analyze the balance sheet. Please note though, that to fully automate multi-company analysis of balance sheet year-to-date balances where companies within the group uses different fiscal years the period mapping functionality in IFS group consolidation is recommended.

Accounting Period

In some cases, it is relevant to do reporting and analysis according to the local accounting calendar used in a company, e.g. when it is different to the reporting calendar or for more detailed analysis of the balance sheet.

To analyze the income statement according to the accounting calendar the accounting period dimension can be used. However, since many of the calculated measures are based on the reporting period calendar (such as Opening Balances and Year to date, previous year etc.) not all measures can be analyzed combination with the accounting calendar.

Most suitable for this type of analysis is the basic period measures for ACT, BUD, CFC and NFC.

The balance sheet can also be analyzed using the accounting periods, but for this purpose, specific accounting period measures (separate folder) have been created. The benefit when using these measures is that it is possible to display period 0 (the opening balance period) separately in for example a Power BI matrix visualization. It also adds the possibility to correctly display YTD balances for accounting calendars not equal to the Reporting Calendar used in the Analysis model. Furthermore, these measures can be used for multi-company analysis as long as the selected companies in the report/analysis use the same accounting calendar and the same accounting currency.

Fact Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
BUSINESS PLANNING MEASURESFACT_PLAN_TRANS_VALID_TMFACT_PLAN_TRANS_VALID_BIFACT_PLAN_TRANS_VALIDData Mart
GL ANALYSIS MEASURESFACT_TRANS_BAL_SET_AM_CONF_TMFACT_GL_TRANSACTION_BI, FACT_GL_BALANCE_BI, FACT_GL_PERIOD_BUDGET_BI, FACT_PLAN_TRANS_VALID_BIFACT_GL_TRANSACTION, FACT_GL_BALANCE, FACT_GL_PERIOD_BUDGET, FACT_PLAN_TRANS_VALIDData Mart

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

The GL model has two main end user sources that support standard GL analysis as well as detailed analysis of planning and budgeting:

  1. GL ANALYSIS
    Based on the following Information Sources that are used to retrieve transaction data based on GL Balance Set Configuration and GL Balance Set Configuration for Analysis Models.
    1. FACT_GL_TRANSACTION
      Contributes with General Ledger transactions. Supports some transaction level attributes for traceability.
    2. FACT_GL_BALANCE
      Contributes with opening balances from GL Balance in Financials.
    3. FACT_PLAN_TRANS_VALID
      Contributes with valid Business Planning transactions that typically represents budgeting, forecasting and planning.
    4. FACT_GL_PERIOD_BUDGET
      Contributes with GL budget transactions.
  2. BUSINESS PLANNING
    This source is puerly meant to support detail analysis of planning and budgeting and is based on the following Information Sources;
    1. FACT_PLAN_TRANS_VALID
      Valid Business Planning transactions that typically represents budgeting, forecasting and planning.

Dimension Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACCOUNTDIM_ACCOUNT_FINANCIALS_TMDIM_ACCOUNT_BIDIM_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 1DIM_ACC_ATTR1_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 2DIM_ACC_ATTR2_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 3DIM_ACC_ATTR3_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 4DIM_ACC_ATTR4_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_ACCOUNTOn Line
ACCOUNT ATTRIBUTE 5DIM_ACC_ATTR5_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_ACCOUNTOn Line
ACCOUNTING PERIODDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIODOn Line
ACCOUNTING PROJECTDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECTOn Line
BUSINESS PLANDIM_BUSINESS_PLAN_TMDIM_BUSINESS_PLAN_BIDIM_BUSINESS_PLANOn Line
BUSINESS PLAN RLSBUSINESS_PLAN_RLSN/AN/A
BUSINESS PLANNINGFACT_PLAN_TRANS_VALID_TMFACT_PLAN_TRANS_VALID_BIFACT_PLAN_TRANS_VALIDData Mart
CODE BDIM_CODE_B_TMDIM_CODE_B_BIDIM_CODE_BOn Line
CODE B ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_BOn Line
CODE B ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_BOn Line
CODE B ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_BOn Line
CODE B ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_BOn Line
CODE B ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_B_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_BOn Line
CODE CDIM_CODE_C_TMDIM_CODE_C_BIDIM_CODE_COn Line
CODE C ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_COn Line
CODE C ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_COn Line
CODE C ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_COn Line
CODE C ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_COn Line
CODE C ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_C_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_COn Line
CODE COMP COMBINATIONDIM_CODE_COMP_COMBINATION_TMCODESTRING_COMBINATION_BIADIM_CODE_COMP_COMBINATIONOn Line
CODE DDIM_CODE_D_TMDIM_CODE_D_BIDIM_CODE_DOn Line
CODE D ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_DOn Line
CODE D ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_DOn Line
CODE D ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_DOn Line
CODE D ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_DOn Line
CODE D ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_D_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_DOn Line
CODE EDIM_CODE_E_TMDIM_CODE_E_BIDIM_CODE_EOn Line
CODE E ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_EOn Line
CODE E ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_EOn Line
CODE E ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_EOn Line
CODE E ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_EOn Line
CODE E ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_E_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_EOn Line
CODE FDIM_CODE_F_TMDIM_CODE_F_BIDIM_CODE_FOn Line
CODE F ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_FOn Line
CODE F ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_FOn Line
CODE F ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_FOn Line
CODE F ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_FOn Line
CODE F ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_F_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_FOn Line
CODE GDIM_CODE_G_TMDIM_CODE_G_BIDIM_CODE_GOn Line
CODE G ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_GOn Line
CODE G ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_GOn Line
CODE G ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_GOn Line
CODE G ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_GOn Line
CODE G ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_G_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_GOn Line
CODE HDIM_CODE_H_TMDIM_CODE_H_BIDIM_CODE_HOn Line
CODE H ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_HOn Line
CODE H ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_HOn Line
CODE H ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_HOn Line
CODE H ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_HOn Line
CODE H ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_H_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_HOn Line
CODE IDIM_CODE_I_TMDIM_CODE_I_BIDIM_CODE_IOn Line
CODE I ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_IOn Line
CODE I ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_IOn Line
CODE I ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_IOn Line
CODE I ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_IOn Line
CODE I ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_I_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_IOn Line
CODE JDIM_CODE_J_TMDIM_CODE_J_BIDIM_CODE_JOn Line
CODE J ATTRIBUTE 1DIM_ACC_ATTR_1_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_CODE_JOn Line
CODE J ATTRIBUTE 2DIM_ACC_ATTR_2_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_2_CODE_JOn Line
CODE J ATTRIBUTE 3DIM_ACC_ATTR_3_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_3_CODE_JOn Line
CODE J ATTRIBUTE 4DIM_ACC_ATTR_4_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_4_CODE_JOn Line
CODE J ATTRIBUTE 5DIM_ACC_ATTR_5_CODE_J_TMDIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_5_CODE_JOn Line
CODE K COUNTERPART ONEDIM_COUNTER_PART_ONE_TMDIM_COUNTER_PART_ONE_BIDIM_COUNTER_PART_ONEOn Line
CODE L COUNTERPART TWODIM_COUNTER_PART_TWO_TMDIM_COUNTER_PART_TWO_BIDIM_COUNTER_PART_TWOOn Line
CODE MDIM_CODE_M_TMDIM_CODE_M_BIDIM_CODE_MOn Line
CODE NDIM_CODE_N_TMDIM_CODE_N_BIDIM_CODE_NOn Line
CODE ODIM_CODE_O_TMDIM_CODE_O_BIDIM_CODE_OOn Line
CODE PDIM_CODE_P_TMDIM_CODE_P_BIDIM_CODE_POn Line
CODE QDIM_CODE_Q_TMDIM_CODE_Q_BIDIM_CODE_QOn Line
CODE RDIM_CODE_R_TMDIM_CODE_R_BIDIM_CODE_ROn Line
CODE SDIM_CODE_S_TMDIM_CODE_S_BIDIM_CODE_SOn Line
CODE TDIM_CODE_T_TMDIM_CODE_T_BIDIM_CODE_TOn Line
CODESTRING COMBINATION RLSCODESTRING_COMBINATION_RLSCODESTRING_COMBINATION_RLSCODESTRING_COMBINATION_RLSOn Line
COMPANYDIM_COMPANY_BIDIM_COMPANY_BIDIM_COMPANYOn Line
COMPANY STRUCTURE 1DIM_GL_COMP_STRUCT_1_TMDIM_GL_COMP_STRUCT_1_BIDIM_GL_COMP_STRUCT_1On Line
COMPANY STRUCTURE 2DIM_GL_COMP_STRUCT_2_TMDIM_GL_COMP_STRUCT_2_BIDIM_GL_COMP_STRUCT_2On Line
COMPANY STRUCTURE 3DIM_GL_COMP_STRUCT_3_TMDIM_GL_COMP_STRUCT_3_BIDIM_GL_COMP_STRUCT_3On Line
COUNTERPART GLDIM_COUNTERPART_GL_TMDIM_COUNTERPART_GL_BIDIM_COUNTERPART_GLOn Line
COUNTERPART STRUCTURE 1DIM_GL_COUNT_STRUCT_1_TMDIM_GL_COUNT_STRUCT_1_BIDIM_GL_COUNT_STRUCT_1On Line
COUNTERPART STRUCTURE 2DIM_GL_COUNT_STRUCT_2_TMDIM_GL_COUNT_STRUCT_2_BIDIM_GL_COUNT_STRUCT_2On Line
COUNTERPART STRUCTURE 3DIM_GL_COUNT_STRUCT_3_TMDIM_GL_COUNT_STRUCT_3_BIDIM_GL_COUNT_STRUCT_3On Line
CURRENCY CODEDIM_CURRENCY_CODE_TMDIM_CURRENCY_CODE_BIDIM_CURRENCY_CODEOn Line
CURRENCY CODE X RATEDIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
CURRENCY CODE X-RATE 1DIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
CURRENCY CODE X-RATE 2DIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
CURRENCY RATE TYPE XRATEDIM_CURRENCY_RATE_TYPE_XRATE_TMDIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCDIM_CURRENCY_RATE_TYPE_XRATEOn Line
CURRENCY RATES PERIODXRATEFACT_CURRENCY_RATES_PERIODXRATEDIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCFACT_CURRENCY_RATES_PERIODXRATEData Mart
GL COMPANY RLSGL_COMPANY_RLSN/AN/A
INTERCOMPANY PAIRSDIM_INTERCOMPANY_MAPPING_TMDIM_INTERCOMPANY_MAPPING_BIDIM_INTERCOMPANY_MAPPINGOn Line
MEASURE LIST ACTUALGL_MEASURE_LIST_ACTUALN/AN/A
MEASURE LIST COMPARISONBI_Measure_List_ComparisonN/AN/A
PLANNING UNITDIM_PLANNING_UNIT_TMDIM_PLANNING_UNIT_BIDIM_PLANNING_UNITOn Line
PLANNING UNIT RLSPLANNING_UNIT_RLSN/AN/A
RATE TYPE X-RATE 1DIM_CURRENCY_RATE_TYPE_XRATE_TMDIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCDIM_CURRENCY_RATE_TYPE_XRATEOn Line
RATE TYPE X-RATE 2DIM_CURRENCY_RATE_TYPE_XRATE_TMDIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCDIM_CURRENCY_RATE_TYPE_XRATEOn Line
REPORTING FROM CURRENCYDIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
REPORTING FROM CURRENCY 2DIM_CURRENCY_CODE_XRATE_TMDIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TCDIM_CURRENCY_CODE_XRATEOn Line
REPORTING PERIODDIM_REPORTING_PERIOD__TM, alt DIM_BI_TIME_BI combined with DIM_RDP_COMPANY_PERIOD_BI to DIM_BI_TIME_TMDIM_RDP_COMPANY_PERIOD_BIDIM_RDP_COMPANY_PERIODOn Line
SWITCH COMPARISON MEASUREBI_Switch_Comparison_MeasureN/AN/A
SWITCH CURRENCY TYPEBI_Switch_Currency_TypeN/AN/A
SWITCH DISPLAY UNITBI_Switch_Display_UnitN/AN/A
SWITCH TIME PERSPECTIVEBI_Switch_Time_PerspectiveN/AN/A
VOUCHER TYPEDIM_VOUCHER_TYPE_BIDIM_VOUCHER_TYPE_BIDIM_VOUCHER_TYPEOn Line
X-RATES 1FACT_CURRENCY_RATES_PERIODXRATEDIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCFACT_CURRENCY_RATES_PERIODXRATEData Mart
X-RATES 2FACT_CURRENCY_RATES_PERIODXRATEDIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TCFACT_CURRENCY_RATES_PERIODXRATEData Mart

Configurations

By defining company structures in IFS Cloud, dynamic out of the box analysis capabilities are provided. To achieve a consolidated view on node level, the node can be selected from the Company Structure and on the same time deselected from the Counterpart Structure. Can configure up to three different Company and Counterpart structures.

By mapping code part values for counterparts to relevant companies in IFS Cloud it is possible to reconcile your intercompany transactions. Use dimension Intercompany Pairs in combination with your intercompany accounts to highlight potential differences at an early stage.

Refer to Technical Documentation for more information.

Limitations

Refer to Technical Documentation for more information.

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)
BUSINESS PLANNING (dim_account_id) - ACCOUNT (ID)
BUSINESS PLANNING (dim_business_plan_id) - BUSINESS PLAN (ID)
BUSINESS PLANNING (dim_code_b_id) - CODE B (ID)
BUSINESS PLANNING (dim_code_c_id) - CODE C (ID)
BUSINESS PLANNING (dim_code_d_id) - CODE D (ID)
BUSINESS PLANNING (dim_code_e_id) - CODE E (ID)
BUSINESS PLANNING (dim_code_f_id) - CODE F (ID)
BUSINESS PLANNING (dim_code_g_id) - CODE G (ID)
BUSINESS PLANNING (dim_code_h_id) - CODE H (ID)
BUSINESS PLANNING (dim_code_i_id) - CODE I (ID)
BUSINESS PLANNING (dim_code_j_id) - CODE J (ID)
BUSINESS PLANNING (dim_code_m_id) - CODE M (ID)
BUSINESS PLANNING (dim_code_n_id) - CODE N (ID)
BUSINESS PLANNING (dim_code_o_id) - CODE O (ID)
BUSINESS PLANNING (dim_code_p_id) - CODE P (ID)
BUSINESS PLANNING (dim_code_q_id) - CODE Q (ID)
BUSINESS PLANNING (dim_code_r_id) - CODE R (ID)
BUSINESS PLANNING (dim_code_s_id) - CODE S (ID)
BUSINESS PLANNING (dim_code_t_id) - CODE T (ID)
BUSINESS PLANNING (dim_company_id) - COMPANY (ID)
BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 1 (Company)
BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 2 (Company)
BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 3 (Company)
BUSINESS PLANNING (dim_counter_part_one_id) - CODE K COUNTERPART ONE (ID)
BUSINESS PLANNING (dim_counter_part_two_id) - CODE L COUNTERPART TWO (ID)
BUSINESS PLANNING (dim_currency_code_id) - CURRENCY CODE (ID)
BUSINESS PLANNING (dim_planning_unit_id) - PLANNING STRUCTURE (ID)
BUSINESS PLANNING (dim_planning_unit_id) - PLANNING UNIT (ID)
BUSINESS PLANNING (dim_posting_comb_comp_id) - CODE COMP COMBINATION (ID)
BUSINESS PLANNING (dim_reporting_date_id) - REPORTING PERIOD (ID)
BUSINESS PLAN RLS (DIM_BUSINESS_PLAN_ID) - BUSINESS PLAN (ID)
CODESTRING COMBINATION RLS (POST_COMB_COMP_ID) - CODE COMP COMBINATION (ID)
GL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY (Currency Code)
GL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY 2 (Currency Code)
GL ANALYSIS (dim_accounting_period_id) - ACCOUNTING PERIOD (ID)
GL ANALYSIS (dim_accounting_project_id) - ACCOUNTING PROJECT (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 1 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 2 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 3 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 4 (ID)
GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 5 (ID)
GL ANALYSIS (dim_company_id) - COMPANY (ID)
GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 1 (Company)
GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 2 (Company)
GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 3 (Company)
GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART GL (ID)
GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 1 (Counterpart)
GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 2 (Counterpart)
GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 3 (Counterpart)
GL ANALYSIS (dim_currency_code_id) - CURRENCY CODE (ID)
GL ANALYSIS (dim_intercompany_pairs_id) - INTERCOMPANY PAIRS (ID)
GL ANALYSIS (dim_posting_comb_comp_id) - CODE COMP COMBINATION (ID)
GL ANALYSIS (dim_reporting_date_id) - REPORTING PERIOD (ID)
GL ANALYSIS (dim_voucher_type_id) - VOUCHER TYPE (ID)
GL COMPANY RLS (COMPANY) - COMPANY (ID)
MEASURE LIST ACTUAL (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index)
MEASURE LIST ACTUAL (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index)
MEASURE LIST COMPARISON (Dim Comparison Id) - SWITCH COMPARISON MEASURE (Row Index)
MEASURE LIST COMPARISON (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index)
MEASURE LIST COMPARISON (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index)
PLANNING UNIT RLS (DIM_PLANNING_UNIT_ID) - PLANNING UNIT (ID)
X-RATES 1 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID)
X-RATES 1 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 1 (Rate Type Code X-Rate 1)
X-RATES 1 (FROMCURRENCY) - REPORTING FROM CURRENCY (Currency Code)
X-RATES 1 (TOCURRENCY) - CURRENCY CODE X-RATE 1 (Currency Code X-Rate 1)
X-RATES 2 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID)
X-RATES 2 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 2 (Rate Type Code X-Rate 2)
X-RATES 2 (FROMCURRENCY) - REPORTING FROM CURRENCY 2 (Currency Code)
X-RATES 2 (TOCURRENCY) - CURRENCY CODE X-RATE 2 (Currency Code X-Rate 2)